Leibel S Community Champion

Overview

Overview

Roles	Member
Badges	33

About Me

About Me

Area of Expertise
About Me
How I Use Smartsheet
Linkedin
Twitter Page

Analytics

848

Posts

1,548

Visits

10.9k

Points

Oct 12, 2020

Join Date

Mar 7, 2025

Last Active

Reactions

• Promote 1

  1
• Insightful 42

  42
• Vote Up 247

  247
• Awesome 72

  72

• Activity
• Discussions6
• Comments842

• Re: Formula Issue

  Leibel S

  02/19/25
  @Cynde Ashcraft See below, i added in the beginning an IF statement to check for a date, then i also changed your formula to make it a bit smaller by adding the year at the end only one time… =IF(ISD…
  1 ·

• Re: Maxif Next Date to Review

  Leibel S

  02/04/25
  @Pestomania You would use a MAX(COLLECT()) Combo. So something like this: =MAX(COLLECT([Date]:[Date],[Document Name]:[Document Name],@cell=[Document Name]@row))
  2 ·

• Re: How to add varying months to varying dates?

  Leibel S

  01/30/25
  @S.Stone I see what happened here: the below should fix it =DATE(YEAR([Date Contract Executed]@row) + ROUNDDOWN(([Months Until Expiration]@row + MONTH([Date Contract Executed]@row)) / 12.00001, 0), R…
  2 ·

• Re: Is there a way to have automation to run monthly?

  Leibel S

  01/20/25
  @tracyashton The option is right there:
  1 ·

• Re: Formula to Evaluate Multi-Selection and Sum Individual Associated Values

  Leibel S

  01/16/25
  @Brian McElligott See below how you would do that: =SUMIFS(Price1:Price3, Item1:Item3, HAS([User Selection (Multi-Select Drop Down)]@row, @cell))
  1 ·

Next